Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	7852
Missing cells	20
Missing cells (%)	< 0.1%
Duplicate rows	605
Duplicate rows (%)	7.7%
Total size in memory	1012.3 KiB
Average record size in memory	132.0 B

Variable types

Categorical	7
Text	1
Numeric	10

Alerts

Dataset has 605 (7.7%) duplicate rows	Duplicates
`year` is highly overall correlated with `car_age` and 2 other fields	High correlation
`car_age` is highly overall correlated with `year` and 2 other fields	High correlation
`selling_price` is highly overall correlated with `year` and 4 other fields	High correlation
`km_driven` is highly overall correlated with `year` and 1 other fields	High correlation
`seats` is highly overall correlated with `engine_vol_num`	High correlation
`engine_vol_num` is highly overall correlated with `selling_price` and 2 other fields	High correlation
`max_power_num` is highly overall correlated with `selling_price` and 2 other fields	High correlation
`capital_gps_lat` is highly overall correlated with `company` and 2 other fields	High correlation
`capital_gps_lng` is highly overall correlated with `company` and 2 other fields	High correlation
`company` is highly overall correlated with `capital_gps_lat` and 4 other fields	High correlation
`transmission` is highly overall correlated with `selling_price` and 3 other fields	High correlation
`country` is highly overall correlated with `capital_gps_lat` and 4 other fields	High correlation
`region` is highly overall correlated with `capital_gps_lat` and 3 other fields	High correlation
`seller_type` is highly imbalanced (51.7%)	Imbalance

Reproduction

Analysis started	2023-08-28 23:09:56.270092
Analysis finished	2023-08-28 23:10:08.726886
Duration	12.46 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

company
Categorical

HIGH CORRELATION

Distinct	30
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	61.5 KiB

Maruti	2367
Hyundai	1360
Mahindra	758
Tata	719
Honda	466
Other values (25)	2182

Length

Max length	10
Median length	9
Mean length	6.1392002
Min length	2

Characters and Unicode

Total characters	48205
Distinct characters	42
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Maruti
2nd row	Skoda
3rd row	Honda
4th row	Hyundai
5th row	Maruti

Common Values

Value	Count	Frequency (%)
Maruti	2367	30.1%
Hyundai	1360	17.3%
Mahindra	758	9.7%
Tata	719	9.2%
Honda	466	5.9%
Toyota	452	5.8%
Ford	388	4.9%
Chevrolet	230	2.9%
Renault	228	2.9%
Volkswagen	185	2.4%
Other values (20)	699	8.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
maruti	2367	30.1%
hyundai	1360	17.3%
mahindra	758	9.7%
tata	719	9.2%
honda	466	5.9%
toyota	452	5.8%
ford	388	4.9%
chevrolet	230	2.9%
renault	228	2.9%
volkswagen	185	2.4%
Other values (20)	699	8.9%

Most occurring characters

Value	Count	Frequency (%)
a	8466	17.6%
i	4693	9.7%
u	4189	8.7%
t	4116	8.5%
r	3824	7.9%
M	3260	6.8%
n	3149	6.5%
d	3126	6.5%
o	2428	5.0%
H	1826	3.8%
Other values (32)	9128	18.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	40114	83.2%
Uppercase Letter	8091	16.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	8466	21.1%
i	4693	11.7%
u	4189	10.4%
t	4116	10.3%
r	3824	9.5%
n	3149	7.9%
d	3126	7.8%
o	2428	6.1%
y	1812	4.5%
h	1003	2.5%
Other values (13)	3308	8.2%

Uppercase Letter

Value	Count	Frequency (%)
M	3260	40.3%
H	1826	22.6%
T	1171	14.5%
F	435	5.4%
V	252	3.1%
C	230	2.8%
R	228	2.8%
B	118	1.5%
W	118	1.5%
S	104	1.3%
Other values (9)	349	4.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	48205	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	8466	17.6%
i	4693	9.7%
u	4189	8.7%
t	4116	8.5%
r	3824	7.9%
M	3260	6.8%
n	3149	6.5%
d	3126	6.5%
o	2428	5.0%
H	1826	3.8%
Other values (32)	9128	18.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48205	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	8466	17.6%
i	4693	9.7%
u	4189	8.7%
t	4116	8.5%
r	3824	7.9%
M	3260	6.8%
n	3149	6.5%
d	3126	6.5%
o	2428	5.0%
H	1826	3.8%
Other values (32)	9128	18.9%

model
Text

Distinct	1947
Distinct (%)	24.8%
Missing	0
Missing (%)	0.0%
Memory size	61.5 KiB

Length

Max length	45
Median length	36
Mean length	18.016938
Min length	4

Characters and Unicode

Total characters	141469
Distinct characters	68
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	767 ?
Unique (%)	9.8%

Sample

1st row	Swift Dzire VDI
2nd row	Rapid 1.5 TDI Ambition
3rd row	City 2017-2020 EXi
4th row	i20 Sportz Diesel
5th row	Swift VXI BSIII

Value	Count	Frequency (%)
swift	729	2.5%
diesel	677	2.3%
bsiv	672	2.3%
1.2	586	2.0%
vxi	546	1.9%
plus	529	1.8%
vdi	472	1.6%
lxi	440	1.5%
crdi	428	1.5%
alto	418	1.4%
Other values (767)	23792	81.2%

Most occurring characters

Value	Count	Frequency (%)
	21438	15.2%
i	8289	5.9%
e	6259	4.4%
a	5909	4.2%
t	5738	4.1%
o	5634	4.0%
S	5176	3.7%
r	4888	3.5%
I	4594	3.2%
n	4206	3.0%
Other values (58)	69338	49.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	60231	42.6%
Uppercase Letter	42303	29.9%
Space Separator	21438	15.2%
Decimal Number	13732	9.7%
Other Punctuation	2548	1.8%
Dash Punctuation	675	0.5%
Close Punctuation	271	0.2%
Open Punctuation	271	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	8289	13.8%
e	6259	10.4%
a	5909	9.8%
t	5738	9.5%
o	5634	9.4%
r	4888	8.1%
n	4206	7.0%
l	3346	5.6%
s	2549	4.2%
p	1603	2.7%
Other values (16)	11810	19.6%

Uppercase Letter

Value	Count	Frequency (%)
S	5176	12.2%
I	4594	10.9%
D	3926	9.3%
V	3808	9.0%
X	3473	8.2%
T	2644	6.3%
C	2142	5.1%
A	2085	4.9%
B	1911	4.5%
L	1889	4.5%
Other values (16)	10655	25.2%

Decimal Number

Value	Count	Frequency (%)
1	3447	25.1%
0	3376	24.6%
2	2803	20.4%
5	979	7.1%
4	954	6.9%
8	637	4.6%
6	455	3.3%
3	420	3.1%
7	357	2.6%
9	304	2.2%

Other Punctuation

Value	Count	Frequency (%)
.	2535	99.5%
/	13	0.5%

Space Separator

Value	Count	Frequency (%)
	21438	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	675	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	271	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	271	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	102534	72.5%
Common	38935	27.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	8289	8.1%
e	6259	6.1%
a	5909	5.8%
t	5738	5.6%
o	5634	5.5%
S	5176	5.0%
r	4888	4.8%
I	4594	4.5%
n	4206	4.1%
D	3926	3.8%
Other values (42)	47915	46.7%

Common

Value	Count	Frequency (%)
	21438	55.1%
1	3447	8.9%
0	3376	8.7%
2	2803	7.2%
.	2535	6.5%
5	979	2.5%
4	954	2.5%
-	675	1.7%
8	637	1.6%
6	455	1.2%
Other values (6)	1636	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	141469	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	21438	15.2%
i	8289	5.9%
e	6259	4.4%
a	5909	4.2%
t	5738	4.1%
o	5634	4.0%
S	5176	3.7%
r	4888	3.5%
I	4594	3.2%
n	4206	3.0%
Other values (58)	69338	49.0%

year
Real number (ℝ)

HIGH CORRELATION

Distinct	27
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.984

Minimum	1994
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.5 KiB

Quantile statistics

Minimum	1994
5-th percentile	2007
Q1	2012
median	2015
Q3	2017
95-th percentile	2019
Maximum	2020
Range	26
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.8654609
Coefficient of variation (CV)	0.0019193107
Kurtosis	1.2832171
Mean	2013.984
Median Absolute Deviation (MAD)	3
Skewness	-0.99646791
Sum	15813802
Variance	14.941788
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
2017	999	12.7%
2016	848	10.8%
2018	801	10.2%
2015	773	9.8%
2013	664	8.5%
2012	620	7.9%
2014	615	7.8%
2019	581	7.4%
2011	562	7.2%
2010	374	4.8%
Other values (17)	1015	12.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1994	2	< 0.1%
1995	1	< 0.1%
1996	2	< 0.1%
1997	9	0.1%
1998	9	0.1%
1999	14	0.2%
2000	15	0.2%
2001	6	0.1%
2002	19	0.2%
2003	37	0.5%

Value	Count	Frequency (%)
2020	74	0.9%
2019	581	7.4%
2018	801	10.2%
2017	999	12.7%
2016	848	10.8%
2015	773	9.8%
2014	615	7.8%
2013	664	8.5%
2012	620	7.9%
2011	562	7.2%

car_age
Real number (ℝ)

HIGH CORRELATION

Distinct	27
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0160469

Minimum	0
Maximum	26
Zeros	74
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	61.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	5
Q3	8
95-th percentile	13
Maximum	26
Range	26
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.8654609
Coefficient of variation (CV)	0.64252507
Kurtosis	1.2832171
Mean	6.0160469
Median Absolute Deviation (MAD)	3
Skewness	0.99646791
Sum	47238
Variance	14.941788
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
3	999	12.7%
4	848	10.8%
2	801	10.2%
5	773	9.8%
7	664	8.5%
8	620	7.9%
6	615	7.8%
1	581	7.4%
9	562	7.2%
10	374	4.8%
Other values (17)	1015	12.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	74	0.9%
1	581	7.4%
2	801	10.2%
3	999	12.7%
4	848	10.8%
5	773	9.8%
6	615	7.8%
7	664	8.5%
8	620	7.9%
9	562	7.2%

Value	Count	Frequency (%)
26	2	< 0.1%
25	1	< 0.1%
24	2	< 0.1%
23	9	0.1%
22	9	0.1%
21	14	0.2%
20	15	0.2%
19	6	0.1%
18	19	0.2%
17	37	0.5%

selling_price
Real number (ℝ)

HIGH CORRELATION

Distinct	658
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	637292.83

Minimum	29999
Maximum	10000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.5 KiB

Quantile statistics

Minimum	29999
5-th percentile	120000
Q1	265000
median	450000
Q3	680000
95-th percentile	1856749.5
Maximum	10000000
Range	9970001
Interquartile range (IQR)	415000

Descriptive statistics

Standard deviation	792549.3
Coefficient of variation (CV)	1.2436187
Kurtosis	22.037424
Mean	637292.83
Median Absolute Deviation (MAD)	200000
Skewness	4.2780637
Sum	5.0040233 × 10⁹
Variance	6.2813439 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300000	221	2.8%
600000	211	2.7%
550000	204	2.6%
350000	204	2.6%
450000	194	2.5%
650000	187	2.4%
500000	175	2.2%
250000	173	2.2%
400000	170	2.2%
700000	148	1.9%
Other values (648)	5965	76.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
29999	1	< 0.1%
30000	1	< 0.1%
31000	1	< 0.1%
31504	1	< 0.1%
33351	1	< 0.1%
35000	3	< 0.1%
39000	1	< 0.1%
40000	11	0.1%
42000	2	< 0.1%
45000	21	0.3%

Value	Count	Frequency (%)
10000000	1	< 0.1%
7200000	1	< 0.1%
6523000	1	< 0.1%
6223000	1	< 0.1%
6000000	3	< 0.1%
5923000	1	< 0.1%
5830000	2	< 0.1%
5800000	2	< 0.1%
5500000	33	0.4%
5400000	30	0.4%

km_driven
Real number (ℝ)

HIGH CORRELATION

Distinct	894
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69305.752

Minimum	1
Maximum	2360457
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.5 KiB

Quantile statistics

Minimum	1
5-th percentile	9000
Q1	35000
median	60000
Q3	96000
95-th percentile	150000
Maximum	2360457
Range	2360456
Interquartile range (IQR)	61000

Descriptive statistics

Standard deviation	56911.848
Coefficient of variation (CV)	0.82117063
Kurtosis	387.9761
Mean	69305.752
Median Absolute Deviation (MAD)	30000
Skewness	11.344192
Sum	5.4418876 × 10⁸
Variance	3.2389584 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120000	508	6.5%
70000	437	5.6%
80000	426	5.4%
60000	411	5.2%
50000	377	4.8%
100000	321	4.1%
90000	316	4.0%
40000	302	3.8%
110000	298	3.8%
30000	243	3.1%
Other values (884)	4213	53.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
1000	6	0.1%
1300	1	< 0.1%
1303	5	0.1%
1500	3	< 0.1%
1600	1	< 0.1%
1620	1	< 0.1%
2000	35	0.4%
2118	1	< 0.1%
2136	1	< 0.1%

Value	Count	Frequency (%)
2360457	1	< 0.1%
1500000	1	< 0.1%
577414	1	< 0.1%
500000	2	< 0.1%
475000	1	< 0.1%
440000	1	< 0.1%
426000	1	< 0.1%
380000	1	< 0.1%
376412	1	< 0.1%
375000	1	< 0.1%

seats
Real number (ℝ)

HIGH CORRELATION

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.4187468

Minimum	2
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.5 KiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	5
median	5
Q3	5
95-th percentile	7
Maximum	14
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.96156957
Coefficient of variation (CV)	0.17745239
Kurtosis	3.7655582
Mean	5.4187468
Median Absolute Deviation (MAD)	0
Skewness	1.9620805
Sum	42548
Variance	0.92461603
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
5	6202	79.0%
7	1118	14.2%
8	235	3.0%
4	133	1.7%
9	80	1.0%
6	62	0.8%
10	19	0.2%
2	2	< 0.1%
14	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	2	< 0.1%
4	133	1.7%
5	6202	79.0%
6	62	0.8%
7	1118	14.2%
8	235	3.0%
9	80	1.0%
10	19	0.2%
14	1	< 0.1%

Value	Count	Frequency (%)
14	1	< 0.1%
10	19	0.2%
9	80	1.0%
8	235	3.0%
7	1118	14.2%
6	62	0.8%
5	6202	79.0%
4	133	1.7%
2	2	< 0.1%

seller_type
Categorical

IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	61.5 KiB

Individual	6535
Dealer	1081
Trustmark Dealer	236

Length

Max length	16
Median length	10
Mean length	9.6296485
Min length	6

Characters and Unicode

Total characters	75612
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Individual
2nd row	Individual
3rd row	Individual
4th row	Individual
5th row	Individual

Common Values

Value	Count	Frequency (%)
Individual	6535	83.2%
Dealer	1081	13.8%
Trustmark Dealer	236	3.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
individual	6535	80.8%
dealer	1317	16.3%
trustmark	236	2.9%

Most occurring characters

Value	Count	Frequency (%)
d	13070	17.3%
i	13070	17.3%
a	8088	10.7%
l	7852	10.4%
u	6771	9.0%
I	6535	8.6%
v	6535	8.6%
n	6535	8.6%
e	2634	3.5%
r	1789	2.4%
Other values (7)	2733	3.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	67288	89.0%
Uppercase Letter	8088	10.7%
Space Separator	236	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	13070	19.4%
i	13070	19.4%
a	8088	12.0%
l	7852	11.7%
u	6771	10.1%
v	6535	9.7%
n	6535	9.7%
e	2634	3.9%
r	1789	2.7%
s	236	0.4%
Other values (3)	708	1.1%

Uppercase Letter

Value	Count	Frequency (%)
I	6535	80.8%
D	1317	16.3%
T	236	2.9%

Space Separator

Value	Count	Frequency (%)
	236	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	75376	99.7%
Common	236	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
d	13070	17.3%
i	13070	17.3%
a	8088	10.7%
l	7852	10.4%
u	6771	9.0%
I	6535	8.7%
v	6535	8.7%
n	6535	8.7%
e	2634	3.5%
r	1789	2.4%
Other values (6)	2497	3.3%

Common

Value	Count	Frequency (%)
	236	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	75612	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
d	13070	17.3%
i	13070	17.3%
a	8088	10.7%
l	7852	10.4%
u	6771	9.0%
I	6535	8.6%
v	6535	8.6%
n	6535	8.6%
e	2634	3.5%
r	1789	2.4%
Other values (7)	2733	3.6%

fuel
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	61.5 KiB

Diesel	4259
Petrol	3506
CNG	52
LPG	35

Length

Max length	6
Median length	6
Mean length	5.9667601
Min length	3

Characters and Unicode

Total characters	46851
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Diesel
2nd row	Diesel
3rd row	Petrol
4th row	Diesel
5th row	Petrol

Common Values

Value	Count	Frequency (%)
Diesel	4259	54.2%
Petrol	3506	44.7%
CNG	52	0.7%
LPG	35	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
diesel	4259	54.2%
petrol	3506	44.7%
cng	52	0.7%
lpg	35	0.4%

Most occurring characters

Value	Count	Frequency (%)
e	12024	25.7%
l	7765	16.6%
D	4259	9.1%
i	4259	9.1%
s	4259	9.1%
P	3541	7.6%
t	3506	7.5%
r	3506	7.5%
o	3506	7.5%
G	87	0.2%
Other values (3)	139	0.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	38825	82.9%
Uppercase Letter	8026	17.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	12024	31.0%
l	7765	20.0%
i	4259	11.0%
s	4259	11.0%
t	3506	9.0%
r	3506	9.0%
o	3506	9.0%

Uppercase Letter

Value	Count	Frequency (%)
D	4259	53.1%
P	3541	44.1%
G	87	1.1%
C	52	0.6%
N	52	0.6%
L	35	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	46851	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	12024	25.7%
l	7765	16.6%
D	4259	9.1%
i	4259	9.1%
s	4259	9.1%
P	3541	7.6%
t	3506	7.5%
r	3506	7.5%
o	3506	7.5%
G	87	0.2%
Other values (3)	139	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46851	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	12024	25.7%
l	7765	16.6%
D	4259	9.1%
i	4259	9.1%
s	4259	9.1%
P	3541	7.6%
t	3506	7.5%
r	3506	7.5%
o	3506	7.5%
G	87	0.2%
Other values (3)	139	0.3%

transmission
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	61.5 KiB

Manual	6863
Automatic	989

Length

Max length	9
Median length	6
Mean length	6.3778655
Min length	6

Characters and Unicode

Total characters	50079
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Manual
2nd row	Manual
3rd row	Manual
4th row	Manual
5th row	Manual

Common Values

Value	Count	Frequency (%)
Manual	6863	87.4%
Automatic	989	12.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manual	6863	87.4%
automatic	989	12.6%

Most occurring characters

Value	Count	Frequency (%)
a	14715	29.4%
u	7852	15.7%
M	6863	13.7%
n	6863	13.7%
l	6863	13.7%
t	1978	3.9%
A	989	2.0%
o	989	2.0%
m	989	2.0%
i	989	2.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	42227	84.3%
Uppercase Letter	7852	15.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	14715	34.8%
u	7852	18.6%
n	6863	16.3%
l	6863	16.3%
t	1978	4.7%
o	989	2.3%
m	989	2.3%
i	989	2.3%
c	989	2.3%

Uppercase Letter

Value	Count	Frequency (%)
M	6863	87.4%
A	989	12.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	50079	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	14715	29.4%
u	7852	15.7%
M	6863	13.7%
n	6863	13.7%
l	6863	13.7%
t	1978	3.9%
A	989	2.0%
o	989	2.0%
m	989	2.0%
i	989	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	50079	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	14715	29.4%
u	7852	15.7%
M	6863	13.7%
n	6863	13.7%
l	6863	13.7%
t	1978	3.9%
A	989	2.0%
o	989	2.0%
m	989	2.0%
i	989	2.0%

owner
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	61.5 KiB

First Owner	5178
Second Owner	2002
Third Owner	507
Fourth & Above Owner	160
Test Drive Car	5

Length

Max length	20
Median length	11
Mean length	11.44027
Min length	11

Characters and Unicode

Total characters	89829
Distinct characters	24
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	First Owner
2nd row	Second Owner
3rd row	Third Owner
4th row	First Owner
5th row	First Owner

Common Values

Value	Count	Frequency (%)
First Owner	5178	65.9%
Second Owner	2002	25.5%
Third Owner	507	6.5%
Fourth & Above Owner	160	2.0%
Test Drive Car	5	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
owner	7847	49.0%
first	5178	32.3%
second	2002	12.5%
third	507	3.2%
fourth	160	1.0%
	160	1.0%
above	160	1.0%
test	5	< 0.1%
drive	5	< 0.1%
car	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
r	13702	15.3%
e	10019	11.2%
n	9849	11.0%
	8177	9.1%
O	7847	8.7%
w	7847	8.7%
i	5690	6.3%
t	5343	5.9%
F	5338	5.9%
s	5183	5.8%
Other values (14)	10834	12.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	65623	73.1%
Uppercase Letter	15869	17.7%
Space Separator	8177	9.1%
Other Punctuation	160	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	13702	20.9%
e	10019	15.3%
n	9849	15.0%
w	7847	12.0%
i	5690	8.7%
t	5343	8.1%
s	5183	7.9%
d	2509	3.8%
o	2322	3.5%
c	2002	3.1%
Other values (5)	1157	1.8%

Uppercase Letter

Value	Count	Frequency (%)
O	7847	49.4%
F	5338	33.6%
S	2002	12.6%
T	512	3.2%
A	160	1.0%
D	5	< 0.1%
C	5	< 0.1%

Space Separator

Value	Count	Frequency (%)
	8177	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	160	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	81492	90.7%
Common	8337	9.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	13702	16.8%
e	10019	12.3%
n	9849	12.1%
O	7847	9.6%
w	7847	9.6%
i	5690	7.0%
t	5343	6.6%
F	5338	6.6%
s	5183	6.4%
d	2509	3.1%
Other values (12)	8165	10.0%

Common

Value	Count	Frequency (%)
	8177	98.1%
&	160	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	89829	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	13702	15.3%
e	10019	11.2%
n	9849	11.0%
	8177	9.1%
O	7847	8.7%
w	7847	8.7%
i	5690	6.3%
t	5343	5.9%
F	5338	5.9%
s	5183	5.8%
Other values (14)	10834	12.1%

mileage_num
Real number (ℝ)

Distinct	374
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.460902

Minimum	0
Maximum	42
Zeros	14
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	30.8 KiB

Quantile statistics

Minimum	0
5-th percentile	12.99
Q1	16.799999
median	19.33
Q3	22.32
95-th percentile	25.83
Maximum	42
Range	42
Interquartile range (IQR)	5.5200005

Descriptive statistics

Standard deviation	4.0056009
Coefficient of variation (CV)	0.20582813
Kurtosis	0.45757288
Mean	19.460902
Median Absolute Deviation (MAD)	2.7299995
Skewness	-0.11096723
Sum	152807
Variance	16.044838
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.89999962	225	2.9%
19.70000076	171	2.2%
18.60000038	164	2.1%
21.10000038	158	2.0%
17	133	1.7%
15.96000004	115	1.5%
16.10000038	111	1.4%
22	111	1.4%
17.79999924	109	1.4%
12.98999977	105	1.3%
Other values (364)	6450	82.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	0.2%
9	4	0.1%
9.5	6	0.1%
10.10000038	2	< 0.1%
10.5	17	0.2%
10.71000004	1	< 0.1%
10.75	3	< 0.1%
10.80000019	1	< 0.1%
10.89999962	3	< 0.1%
10.90999985	5	0.1%

Value	Count	Frequency (%)
42	1	< 0.1%
33.43999863	3	< 0.1%
33	1	< 0.1%
32.52000046	1	< 0.1%
32.25999832	1	< 0.1%
30.45999908	2	< 0.1%
28.39999962	93	1.2%
28.09000015	38	0.5%
27.62000084	6	0.1%
27.39999962	6	0.1%

engine_vol_num
Real number (ℝ)

HIGH CORRELATION

Distinct	115
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1452.9176

Minimum	624
Maximum	3604
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.8 KiB

Quantile statistics

Minimum	624
5-th percentile	796
Q1	1197
median	1248
Q3	1582
95-th percentile	2498
Maximum	3604
Range	2980
Interquartile range (IQR)	385

Descriptive statistics

Standard deviation	499.54134
Coefficient of variation (CV)	0.34381945
Kurtosis	0.76636116
Mean	1452.9176
Median Absolute Deviation (MAD)	248
Skewness	1.1464903
Sum	11408309
Variance	249541.55
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1248	1017	13.0%
1197	832	10.6%
998	453	5.8%
796	443	5.6%
2179	389	5.0%
1498	375	4.8%
1396	321	4.1%
1199	271	3.5%
2494	222	2.8%
2523	195	2.5%
Other values (105)	3334	42.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
624	25	0.3%
793	6	0.1%
796	443	5.6%
799	79	1.0%
814	121	1.5%
909	3	< 0.1%
936	36	0.5%
993	26	0.3%
995	43	0.5%
998	453	5.8%

Value	Count	Frequency (%)
3604	6	0.1%
3198	5	0.1%
2999	3	< 0.1%
2997	2	< 0.1%
2993	17	0.2%
2982	33	0.4%
2967	9	0.1%
2956	21	0.3%
2953	4	0.1%
2835	1	< 0.1%

max_power_num
Real number (ℝ)

HIGH CORRELATION

Distinct	300
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	90.926656

Minimum	32.799999
Maximum	400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.8 KiB

Quantile statistics

Minimum	32.799999
5-th percentile	47.299999
Q1	68.050003
median	82
Q3	102
95-th percentile	170
Maximum	400
Range	367.20001
Interquartile range (IQR)	33.949997

Descriptive statistics

Standard deviation	34.820827
Coefficient of variation (CV)	0.38295511
Kurtosis	3.8578513
Mean	90.926656
Median Absolute Deviation (MAD)	14.959999
Skewness	1.623785
Sum	713956.11
Variance	1212.49
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74	377	4.8%
88.5	222	2.8%
81.80000305	220	2.8%
67	165	2.1%
46.29999924	162	2.1%
67.09999847	151	1.9%
88.69999695	148	1.9%
67.04000092	145	1.8%
47.29999924	141	1.8%
70	141	1.8%
Other values (290)	5980	76.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
32.79999924	2	< 0.1%
34.20000076	21	0.3%
35	22	0.3%
35.5	2	< 0.1%
37	92	1.2%
37.47999954	11	0.1%
37.5	6	0.1%
38	2	< 0.1%
38.40000153	2	< 0.1%
40.29999924	3	< 0.1%

Value	Count	Frequency (%)
400	1	< 0.1%
280	6	0.1%
270.8999939	4	0.1%
265	1	< 0.1%
261.3999939	6	0.1%
258	2	< 0.1%
241.3999939	9	0.1%
241	2	< 0.1%
235	3	< 0.1%
218	3	< 0.1%

country
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	0.1%
Missing	5
Missing (%)	0.1%
Memory size	61.5 KiB

India	3850
South Korea	1367
Japan	1117
United States	649
France	228
Other values (6)	636

Length

Max length	14
Median length	5
Mean length	7.0196253
Min length	5

Characters and Unicode

Total characters	55083
Distinct characters	31
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	India
2nd row	Czech Republic
3rd row	Japan
4th row	South Korea
5th row	India

Common Values

Value	Count	Frequency (%)
India	3850	49.0%
South Korea	1367	17.4%
Japan	1117	14.2%
United States	649	8.3%
France	228	2.9%
Brazil	185	2.4%
Germany	159	2.0%
Czech Republic	104	1.3%
United Kingdom	80	1.0%
Sweden	67	0.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
india	3850	38.3%
south	1367	13.6%
korea	1367	13.6%
japan	1117	11.1%
united	729	7.3%
states	649	6.5%
france	228	2.3%
brazil	185	1.8%
germany	159	1.6%
czech	104	1.0%
Other values (4)	292	2.9%

Most occurring characters

Value	Count	Frequency (%)
a	8713	15.8%
n	6230	11.3%
i	4948	9.0%
d	4726	8.6%
I	3891	7.1%
e	3474	6.3%
t	3435	6.2%
o	2814	5.1%
	2200	4.0%
S	2083	3.8%
Other values (21)	12569	22.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	42836	77.8%
Uppercase Letter	10047	18.2%
Space Separator	2200	4.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	8713	20.3%
n	6230	14.5%
i	4948	11.6%
d	4726	11.0%
e	3474	8.1%
t	3435	8.0%
o	2814	6.6%
r	1939	4.5%
u	1471	3.4%
h	1471	3.4%
Other values (10)	3615	8.4%

Uppercase Letter

Value	Count	Frequency (%)
I	3891	38.7%
S	2083	20.7%
K	1447	14.4%
J	1117	11.1%
U	729	7.3%
F	228	2.3%
B	185	1.8%
G	159	1.6%
C	104	1.0%
R	104	1.0%

Space Separator

Value	Count	Frequency (%)
	2200	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	52883	96.0%
Common	2200	4.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	8713	16.5%
n	6230	11.8%
i	4948	9.4%
d	4726	8.9%
I	3891	7.4%
e	3474	6.6%
t	3435	6.5%
o	2814	5.3%
S	2083	3.9%
r	1939	3.7%
Other values (20)	10630	20.1%

Common

Value	Count	Frequency (%)
	2200	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	55083	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	8713	15.8%
n	6230	11.3%
i	4948	9.0%
d	4726	8.6%
I	3891	7.1%
e	3474	6.3%
t	3435	6.2%
o	2814	5.1%
	2200	4.0%
S	2083	3.8%
Other values (21)	12569	22.8%

region
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	5
Missing (%)	0.1%
Memory size	61.5 KiB

Asia	6334
Americas	834
Europe	679

Length

Max length	8
Median length	4
Mean length	4.5981904
Min length	4

Characters and Unicode

Total characters	36082
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Asia
2nd row	Europe
3rd row	Asia
4th row	Asia
5th row	Asia

Common Values

Value	Count	Frequency (%)
Asia	6334	80.7%
Americas	834	10.6%
Europe	679	8.6%
(Missing)	5	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
asia	6334	80.7%
americas	834	10.6%
europe	679	8.7%

Most occurring characters

Value	Count	Frequency (%)
A	7168	19.9%
s	7168	19.9%
i	7168	19.9%
a	7168	19.9%
e	1513	4.2%
r	1513	4.2%
m	834	2.3%
c	834	2.3%
E	679	1.9%
u	679	1.9%
Other values (2)	1358	3.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	28235	78.3%
Uppercase Letter	7847	21.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	7168	25.4%
i	7168	25.4%
a	7168	25.4%
e	1513	5.4%
r	1513	5.4%
m	834	3.0%
c	834	3.0%
u	679	2.4%
o	679	2.4%
p	679	2.4%

Uppercase Letter

Value	Count	Frequency (%)
A	7168	91.3%
E	679	8.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	36082	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	7168	19.9%
s	7168	19.9%
i	7168	19.9%
a	7168	19.9%
e	1513	4.2%
r	1513	4.2%
m	834	2.3%
c	834	2.3%
E	679	1.9%
u	679	1.9%
Other values (2)	1358	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36082	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	7168	19.9%
s	7168	19.9%
i	7168	19.9%
a	7168	19.9%
e	1513	4.2%
r	1513	4.2%
m	834	2.3%
c	834	2.3%
E	679	1.9%
u	679	1.9%
Other values (2)	1358	3.8%

capital_gps_lat
Real number (ℝ)

HIGH CORRELATION

Distinct	11
Distinct (%)	0.1%
Missing	5
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	33.034125

Minimum	-10.333333
Maximum	59.325117
Zeros	0
Zeros (%)	0.0%
Negative	185
Negative (%)	2.4%
Memory size	61.5 KiB

Quantile statistics

Minimum	-10.333333
5-th percentile	28.614179
Q1	28.614179
median	28.614179
Q3	37.566679
95-th percentile	50.087465
Maximum	59.325117
Range	69.65845
Interquartile range (IQR)	8.9525

Descriptive statistics

Standard deviation	9.4850341
Coefficient of variation (CV)	0.28712836
Kurtosis	8.7364473
Mean	33.034125
Median Absolute Deviation (MAD)	7.06866
Skewness	-1.6131466
Sum	259218.78
Variance	89.965871
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
28.614179	3850	49.0%
37.566679	1367	17.4%
35.682839	1117	14.2%
38.894986	649	8.3%
48.856697	228	2.9%
-10.333333	185	2.4%
52.517036	159	2.0%
50.087465	104	1.3%
51.507322	80	1.0%
59.325117	67	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-10.333333	185	2.4%
28.614179	3850	49.0%
35.682839	1117	14.2%
37.566679	1367	17.4%
38.894986	649	8.3%
41.89332	41	0.5%
48.856697	228	2.9%
50.087465	104	1.3%
51.507322	80	1.0%
52.517036	159	2.0%

Value	Count	Frequency (%)
59.325117	67	0.9%
52.517036	159	2.0%
51.507322	80	1.0%
50.087465	104	1.3%
48.856697	228	2.9%
41.89332	41	0.5%
38.894986	649	8.3%
37.566679	1367	17.4%
35.682839	1117	14.2%
28.614179	3850	49.0%

capital_gps_lng
Real number (ℝ)

HIGH CORRELATION

Distinct	11
Distinct (%)	0.1%
Missing	5
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	73.016153

Minimum	-77.036571
Maximum	139.75946
Zeros	0
Zeros (%)	0.0%
Negative	914
Negative (%)	11.6%
Memory size	61.5 KiB

Quantile statistics

Minimum	-77.036571
5-th percentile	-77.036571
Q1	77.202266
median	77.202266
Q3	126.97829
95-th percentile	139.75946
Maximum	139.75946
Range	216.79603
Interquartile range (IQR)	49.776025

Descriptive statistics

Standard deviation	61.240087
Coefficient of variation (CV)	0.83871971
Kurtosis	0.82669491
Mean	73.016153
Median Absolute Deviation (MAD)	49.776025
Skewness	-1.2234341
Sum	572957.75
Variance	3750.3482
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
77.202266	3850	49.0%
126.978291	1367	17.4%
139.759455	1117	14.2%
-77.036571	649	8.3%
2.351462	228	2.9%
-53.2	185	2.4%
13.38886	159	2.0%
14.421254	104	1.3%
-0.127647	80	1.0%
18.071094	67	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-77.036571	649	8.3%
-53.2	185	2.4%
-0.127647	80	1.0%
2.351462	228	2.9%
12.482932	41	0.5%
13.38886	159	2.0%
14.421254	104	1.3%
18.071094	67	0.9%
77.202266	3850	49.0%
126.978291	1367	17.4%

Value	Count	Frequency (%)
139.759455	1117	14.2%
126.978291	1367	17.4%
77.202266	3850	49.0%
18.071094	67	0.9%
14.421254	104	1.3%
13.38886	159	2.0%
12.482932	41	0.5%
2.351462	228	2.9%
-0.127647	80	1.0%
-53.2	185	2.4%

Auto

Heatmap
Table

	year	car_age	selling_price	km_driven	seats	mileage_num	engine_vol_num	max_power_num	capital_gps_lat	capital_gps_lng	company	seller_type	fuel	transmission	owner	country	region
year	1.000	-1.000	0.706	-0.622	-0.010	0.306	-0.002	0.224	0.102	0.005	0.218	0.179	0.128	0.307	0.273	0.103	0.129
car_age	-1.000	1.000	-0.706	0.622	0.010	-0.306	0.002	-0.224	-0.102	-0.005	0.218	0.179	0.129	0.307	0.273	0.103	0.129
selling_price	0.706	-0.706	1.000	-0.347	0.270	-0.016	0.507	0.666	0.175	0.080	0.498	0.279	0.109	0.579	0.328	0.356	0.372
km_driven	-0.622	0.622	-0.347	1.000	0.228	-0.166	0.246	-0.023	-0.115	0.015	0.069	0.020	0.038	0.028	0.029	0.036	0.000
seats	-0.010	0.010	0.270	0.228	1.000	-0.444	0.525	0.290	-0.169	0.049	0.292	0.062	0.217	0.072	0.041	0.134	0.131
mileage_num	0.306	-0.306	-0.016	-0.166	-0.444	1.000	-0.454	-0.335	-0.080	-0.050	0.261	0.065	0.313	0.192	0.087	0.148	0.094
engine_vol_num	-0.002	0.002	0.507	0.246	0.525	-0.454	1.000	0.738	0.146	0.020	0.456	0.233	0.452	0.488	0.078	0.327	0.406
max_power_num	0.224	-0.224	0.666	-0.023	0.290	-0.335	0.738	1.000	0.258	0.085	0.461	0.250	0.213	0.584	0.090	0.353	0.331
capital_gps_lat	0.102	-0.102	0.175	-0.115	-0.169	-0.080	0.146	0.258	1.000	0.006	0.999	0.243	0.128	0.494	0.069	1.000	0.974
capital_gps_lng	0.005	-0.005	0.080	0.015	0.049	-0.050	0.020	0.085	0.006	1.000	0.999	0.228	0.121	0.443	0.060	1.000	1.000
company	0.218	0.218	0.498	0.069	0.292	0.261	0.456	0.461	0.999	0.999	1.000	0.378	0.271	0.598	0.130	0.999	0.998
seller_type	0.179	0.179	0.279	0.020	0.062	0.065	0.233	0.250	0.243	0.228	0.378	1.000	0.110	0.376	0.170	0.335	0.192
fuel	0.128	0.129	0.109	0.038	0.217	0.313	0.452	0.213	0.128	0.121	0.271	0.110	1.000	0.052	0.029	0.141	0.111
transmission	0.307	0.307	0.579	0.028	0.072	0.192	0.488	0.584	0.494	0.443	0.598	0.376	0.052	1.000	0.172	0.567	0.386
owner	0.273	0.273	0.328	0.029	0.041	0.087	0.078	0.090	0.069	0.060	0.130	0.170	0.029	0.172	1.000	0.080	0.076
country	0.103	0.103	0.356	0.036	0.134	0.148	0.327	0.353	1.000	1.000	0.999	0.335	0.141	0.567	0.080	1.000	0.999
region	0.129	0.129	0.372	0.000	0.131	0.094	0.406	0.331	0.974	1.000	0.998	0.192	0.111	0.386	0.076	0.999	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	company	model	year	car_age	selling_price	km_driven	seats	seller_type	fuel	transmission	owner	mileage_num	engine_vol_num	max_power_num	country	region	capital_gps_lat	capital_gps_lng
0	Maruti	Swift Dzire VDI	2014	6	450000	145500	5	Individual	Diesel	Manual	First Owner	23.400000	1248	74.000000	India	Asia	28.614179	77.202266
1	Skoda	Rapid 1.5 TDI Ambition	2014	6	370000	120000	5	Individual	Diesel	Manual	Second Owner	21.139999	1498	103.519997	Czech Republic	Europe	50.087465	14.421254
2	Honda	City 2017-2020 EXi	2006	14	158000	140000	5	Individual	Petrol	Manual	Third Owner	17.700001	1497	78.000000	Japan	Asia	35.682839	139.759455
3	Hyundai	i20 Sportz Diesel	2010	10	225000	127000	5	Individual	Diesel	Manual	First Owner	23.000000	1396	90.000000	South Korea	Asia	37.566679	126.978291
4	Maruti	Swift VXI BSIII	2007	13	130000	120000	5	Individual	Petrol	Manual	First Owner	16.100000	1298	88.199997	India	Asia	28.614179	77.202266
5	Hyundai	Xcent 1.2 VTVT E Plus	2017	3	440000	45000	5	Individual	Petrol	Manual	First Owner	20.139999	1197	81.860001	South Korea	Asia	37.566679	126.978291
6	Maruti	Wagon R LXI DUO BSIII	2007	13	96000	175000	5	Individual	LPG	Manual	First Owner	17.299999	1061	57.500000	India	Asia	28.614179	77.202266
7	Maruti	800 DX BSII	2001	19	45000	5000	4	Individual	Petrol	Manual	Second Owner	16.100000	796	37.000000	India	Asia	28.614179	77.202266
8	Toyota	Etios VXD	2011	9	350000	90000	5	Individual	Diesel	Manual	First Owner	23.590000	1364	67.099998	Japan	Asia	35.682839	139.759455
9	Ford	Figo Diesel Celebration Edition	2013	7	200000	169000	5	Individual	Diesel	Manual	First Owner	20.000000	1399	68.099998	United States	Americas	38.894986	-77.036571

	company	model	year	car_age	selling_price	km_driven	seats	seller_type	fuel	transmission	owner	mileage_num	engine_vol_num	max_power_num	country	region	capital_gps_lat	capital_gps_lng
7842	Hyundai	i20 Magna	2013	7	380000	25000	5	Individual	Petrol	Manual	First Owner	18.500000	1197	82.849998	South Korea	Asia	37.566679	126.978291
7843	Maruti	Wagon R LXI Optional	2017	3	360000	80000	5	Individual	Petrol	Manual	First Owner	20.510000	998	67.040001	India	Asia	28.614179	77.202266
7844	Hyundai	Santro Xing GLS	2008	12	120000	191000	5	Individual	Petrol	Manual	First Owner	17.920000	1086	62.099998	South Korea	Asia	37.566679	126.978291
7845	Maruti	Wagon R VXI BS IV with ABS	2013	7	260000	50000	5	Individual	Petrol	Manual	Second Owner	18.900000	998	67.099998	India	Asia	28.614179	77.202266
7846	Hyundai	i20 Magna 1.4 CRDi	2014	6	475000	80000	5	Individual	Diesel	Manual	Second Owner	22.540001	1396	88.730003	South Korea	Asia	37.566679	126.978291
7847	Hyundai	i20 Magna	2013	7	320000	110000	5	Individual	Petrol	Manual	First Owner	18.500000	1197	82.849998	South Korea	Asia	37.566679	126.978291
7848	Hyundai	Verna CRDi SX	2007	13	135000	119000	5	Individual	Diesel	Manual	Fourth & Above Owner	16.799999	1493	110.000000	South Korea	Asia	37.566679	126.978291
7849	Maruti	Swift Dzire ZDi	2009	11	382000	120000	5	Individual	Diesel	Manual	First Owner	19.299999	1248	73.900002	India	Asia	28.614179	77.202266
7850	Tata	Indigo CR4	2013	7	290000	25000	5	Individual	Diesel	Manual	First Owner	23.570000	1396	70.000000	India	Asia	28.614179	77.202266
7851	Tata	Indigo CR4	2013	7	290000	25000	5	Individual	Diesel	Manual	First Owner	23.570000	1396	70.000000	India	Asia	28.614179	77.202266

Most frequently occurring

	company	model	year	car_age	selling_price	km_driven	seats	seller_type	fuel	transmission	owner	mileage_num	engine_vol_num	max_power_num	country	region	capital_gps_lat	capital_gps_lng	# duplicates
235	Jaguar	XF 2.0 Diesel Portfolio	2017	3	3200000	45000	5	Dealer	Diesel	Automatic	First Owner	19.330000	1999	177.000000	United Kingdom	Europe	51.507322	-0.127647	34
245	Lexus	ES 300h	2019	1	5150000	20000	5	Dealer	Petrol	Automatic	First Owner	22.370001	2487	214.559998	Japan	Asia	35.682839	139.759455	34
108	Honda	Jazz VX	2016	4	550000	56494	5	Trustmark Dealer	Petrol	Manual	First Owner	18.200001	1199	88.699997	Japan	Asia	35.682839	139.759455	32
551	Toyota	Camry 2.5 Hybrid	2016	4	2000000	68089	5	Trustmark Dealer	Petrol	Automatic	First Owner	19.160000	2494	157.699997	Japan	Asia	35.682839	139.759455	32
80	Honda	Amaze V CVT Petrol BSIV	2019	1	779000	7032	5	Trustmark Dealer	Petrol	Automatic	First Owner	19.000000	1199	88.760002	Japan	Asia	35.682839	139.759455	31
575	Toyota	Innova 2.5 VX (Diesel) 7 Seater	2013	7	750000	79328	7	Trustmark Dealer	Diesel	Manual	Second Owner	12.990000	2494	100.599998	Japan	Asia	35.682839	139.759455	31
16	BMW	X4 M Sport X xDrive20d	2019	1	5400000	7500	5	Dealer	Diesel	Automatic	First Owner	16.780001	1995	190.000000	Germany	Europe	52.517036	13.388860	30
17	BMW	X4 M Sport X xDrive20d	2019	1	5500000	8500	5	Dealer	Diesel	Automatic	First Owner	16.780001	1995	190.000000	Germany	Europe	52.517036	13.388860	30
496	Skoda	Rapid 1.6 MPI AT Elegance	2016	4	645000	11000	5	Dealer	Petrol	Automatic	First Owner	14.300000	1598	103.500000	Czech Republic	Europe	50.087465	14.421254	30
540	Tata	Safari Storme EX	2015	5	503000	110000	7	Individual	Diesel	Manual	First Owner	14.100000	2179	147.940002	India	Asia	28.614179	77.202266	30

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Close Punctuation

Open Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)